﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="misc_Default" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ErrorContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NAV FOODConnectionString %>" SelectCommand="SELECT [Order Date] AS Order_Date, [Posting Date] AS Posting_Date, [Posting Description] AS Posting_Description, [Extended Description] AS Extended_Description, [Buy-from Vendor No_] AS vendor FROM [Epicurean Partners Exchange$Purchase Header]
where [Buy-from Vendor No_] = 'AMC' OR  [Buy-from Vendor No_] = 'ACCENT MICROSYSTEMS' OR  [Buy-from Vendor No_] = 'AMPI' OR  [Buy-from Vendor No_] = 'QUESTECH' OR  [Buy-from Vendor No_] = 'JUMP SOLUTIONS' OR  [Buy-from Vendor No_] = 'MICROG' OR  [Buy-from Vendor No_] = 'MICROPHASE' OR  [Buy-from Vendor No_] = 'VERATECH INC.' OR  [Buy-from Vendor No_] = 'SOLID STATE' OR  [Buy-from Vendor No_] = 'ROMEO V. AUSTRIA' OR  [Buy-from Vendor No_] = 'INTELLIS' OR  [Buy-from Vendor No_] = 'TELTRENDS' OR  [Buy-from Vendor No_] = 'SENCO' ORDER BY [Order Date] DESC"></asp:SqlDataSource>
         
    
          <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1" Width="100%" PageSize="15" AutoGenerateColumns="False" Font-Names="Tahoma" Font-Size="8pt">
              <Columns>
                  <asp:CommandField ButtonType="Button" ShowSelectButton="True" />
                  <asp:BoundField DataField="Posting_Description" HeaderText="Description" SortExpression="Posting_Description" />
                  <asp:BoundField DataField="Extended_Description" HeaderText="Comment" SortExpression="Extended_Description" />
                  <asp:BoundField DataField="vendor" HeaderText="Vendor" SortExpression="vendor" />
                  <asp:BoundField DataField="Order_Date" HeaderText="Order Date" SortExpression="Order_Date" />
                  <asp:BoundField DataField="Posting_Date" HeaderText="Posting Date" SortExpression="Posting_Date" />
              </Columns>
              <FooterStyle BackColor="White" ForeColor="#000066" />
              <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
              <PagerSettings PageButtonCount="15" />
              <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Center" />
              <RowStyle ForeColor="#000066" />
              <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
              <SortedAscendingCellStyle BackColor="#F1F1F1" />
              <SortedAscendingHeaderStyle BackColor="#007DBB" />
              <SortedDescendingCellStyle BackColor="#CAC9C9" />
              <SortedDescendingHeaderStyle BackColor="#00547E" />
          </asp:GridView>
<br />
<br />
</asp:Content>

